Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Retrieving return codes

You can create a stored procedure that provides return code information. For example, it might indicate whether the stored procedure was successful or whether it encountered an error condition.

Example 3–4 shows how 4GL code runs the stored procedure pcust. It uses the PROC–STATUS function and the CLOSE STORED–PROC statement to retrieve the return code and assign the value to the variable stat. The meaning of this return code is defined by the underlying data source.

/* Return status */ DEFINE VAR handle1 AS integer. DEFINE VAR stat AS integer. RUN STORED-PROCEDURE pcust handle1 = PROC-HANDLE (20, output 0, output 0). CLOSE STORED-PROC pcust stat = PROC-STATUS WHERE PROC-HANDLE = handle1. IF stat = 0 THEN DISPLAY “procedure succeeded”.

Example 3–4: Return status example